Business Analyst - Data Analytics
Overview
At Community Financial System, Inc. (CFSI), we are dedicated to providing our customers with friendly, personalized, high-quality financial services and products. Our retail division, Community Bank, N.A., operates more than 200 customer facilities across Upstate New York, Northeastern Pennsylvania, Vermont and Western Massachusetts. Beyond retail banking, we also offer wealth management, investment management, insurance and risk management, and benefit plan administration.
Just as our employees are committed to helping our customers manage their finances, we're committed to our employees. After all, they make it happen for our customers every day.
To ensure our people can enjoy long and successful careers here at CFSI, we offer competitive compensation, great benefits, and professional development and advancement opportunities. As an equal-opportunity workplace and affirmative-action employer, we celebrate and support a diverse workplace for the benefit of all: our employees, customers and communities.
Responsibilities
This position is responsible for using data analytics from various available data sources, including but not limited to internal systems, to provide information regarding customers, markets, competitors, etc. that will measure performance and support business/marketing decisions.
Ability to work independently on strategic, high-level analytics projects along with various departments and stakeholders. Responsibilities include, but are not limited to, gathering data or application requirements. Independently designs and implement solutions for problems and/or opportunities to improve efficiency.
This position performs analysis of data, dashboard preparation, visualization based on reporting requirements, data validation testing, data modeling, and data replication. This position also evaluates functional and technical specifications to fulfill data requirements for key initiatives/projects. Independently develops test plans, validation requirements and documentation to ensure data integrity for analysis and report requests.
• Data integration with various applications/platforms
• Maintain data quality
• Work cross functionally with various banking teams to support, gather requirements and ensure we adhere to best practices
• Oversee data pipelines, data modeling and data documentation for various DA work streams
• Assist with other key initiatives and other related DA projects
• Ability to understand and maintain a view of the big picture while creating detailed, operation level processes, workflows, and requirements.
• Create reports on marketing and sales activities for real-time visualization of cross-channel performance to identify ROI by channels and programs.
• Provide ROI analysis for all marketing campaigns and sales initiatives
• Ability to extract insights from data and drive informed decision-making within the organization. Role will involve utilizing AI/ML algorithms to analyze large datasets, develop predictive models, and create data-driven solutions to address business challenges and opportunities.
• Work with large and varied data sets to formulate lists, reports and analysis that will assist management in the measurement, tracking, and performance of key initiatives and generation of strategic marketing KPIs.
• Deep understanding and functional knowledge of various development tools and SQL flavors. Ability to design, develop and implement various analytics related projects across the organization.
• Should be having minimum 5 years of experience working with relational database like Oracle/Teradata/MYSQL/MS-SQL
• Maintain compliance with data governance and protocols through all processes.
Qualifications
Education/Training: Bachelor's Degree in Computer Science, Information Systems, Marketing, Business, Accounting or other related field.
Skills:
• 2+ years as data engineer or data analyst.
• Experience with Snowflake and DBT.
• Strong working knowledge of Python, SQL, and Git.
• Familiarity with data modeling and data warehousing concepts, preferably with experience using modeling tools like dbt or DataIku.
• Working knowledge with cloud data warehousing, preferably in Snowflake, Azure or similar cloud infrastructure.
• ELT tools, preferably Astronomer and Apache Airflow.
• Experience with BI tools, preferably Power BI.
• Excellent verbal and written communication skills in technical and user-friendly manner, adaptability to changing priorities. Must have the ability to collaborate and work in a team environment.
• Any prior experience/knowledge of AI/ML practices will be given high preference, primarily responsible for leveraging advanced analytics techniques,particularly in artificial intelligence (AI) and machine learning (ML).
• All applicants must be 18 years of age or older.
Experience: Minimum 3-5 years of proven experience in data analysis.
Banking experience preferred.
Other Job Information
Compensation: Commensurate with experience plus potential for annual merit increase. In addition to your competitive salary, you will be rewarded benefits including: 11 paid holidays, paid vacation, Medical, Vision & Dental insurance, 401K with generous match, Pension, Tuition Reimbursement, Banking discounts and the list goes on!
Physical Requirements:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee may be required to stand, walk or sit. Use hands and fingers, handle or feel, reach with hands or arms, and speak and hear. The employee may occasionally be required to lift and or move up to 25 pounds. Specific vision abilities required by this job include close vision, and the ability to focus.
The Company is an Affirmative Action, Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation and gender identity), national origin, citizenship status, age, disability, genetic information, veteran status, or any other characteristic protected by applicable federal, state or local law.
The Company will make reasonable accommodations for qualified individuals with a disability. If you have a physical or mental impairment and would like to request an accommodation with respect to the application process, please contact the Human Resources Department.
Minimum
USD $58,500.00/Yr.
Maximum
USD $88,000.00/Yr.
